A join in which records from two tables are combined and added to the Recordset object only when there are equal values in the joined fields.